Overview

Dataset statistics

Number of variables22
Number of observations7458
Missing cells24729
Missing cells (%)15.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 MiB
Average record size in memory184.0 B

Variable types

NUM21
DATE1

Reproduction

Analysis started2020-06-20 10:04:30.446569
Analysis finished2020-06-20 10:07:06.964647
Versionpandas-profiling v2.6.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
Temp. (°C).1 is highly correlated with Temp. (°C)High Correlation
Temp. (°C) is highly correlated with Temp. (°C).1 and 1 other fieldsHigh Correlation
Temp. (°C).2 is highly correlated with Temp. (°C)High Correlation
UVA-Str. (W/m²) is highly correlated with Globalstr. (W/m²) and 1 other fieldsHigh Correlation
Globalstr. (W/m²) is highly correlated with UVA-Str. (W/m²) and 1 other fieldsHigh Correlation
UVB-Str. (W/m²) is highly correlated with Globalstr. (W/m²) and 1 other fieldsHigh Correlation
Temp. (°C) has 127 (1.7%) missing values Missing
Temp. (°C).1 has 124 (1.7%) missing values Missing
Temp. (°C).2 has 138 (1.9%) missing values Missing
Feuchte (%) has 471 (6.3%) missing values Missing
WG (m/s).1 has 111 (1.5%) missing values Missing
Druck (hPa) has 159 (2.1%) missing values Missing
Globalstr. (W/m²) has 175 (2.3%) missing values Missing
UVA-Str. (W/m²) has 204 (2.7%) missing values Missing
UVB-Str. (W/m²) has 205 (2.7%) missing values Missing
NO (µg/m³) has 748 (10.0%) missing values Missing
NO2 (µg/m³) has 761 (10.2%) missing values Missing
O3 (µg/m³) has 498 (6.7%) missing values Missing
SO2 (µg/m³) has 4322 (58.0%) missing values Missing
CO (mg/m³) has 6181 (82.9%) missing values Missing
Niederschlag (l/m²) has 489 (6.6%) missing values Missing
Str.-Bilanz (W/m²) has 731 (9.8%) missing values Missing
PM10 (µg/m³) has 1615 (21.7%) missing values Missing
PM2.5 (µg/m³) has 6007 (80.5%) missing values Missing
KFZ_ges has 1613 (21.6%) missing values Missing
Niederschlag (l/m²) has 3065 (41.1%) zeros Zeros

Variables

Datum
Date

UNIFORM
Distinct count7457
Unique (%)> 99.9%
Missing0
Missing (%)0.0%
Memory size116.5 KiB
Minimum2000-01-01 00:00:00
Maximum2020-05-31 00:00:00
Histogram

Temp. (°C)
Real number (ℝ)

HIGH CORRELATION
MISSING
Distinct count3646
Unique (%)49.7%
Missing127
Missing (%)1.7%
Infinite0
Infinite (%)0.0%
Mean12.035986280425591
Minimum-11.43
Maximum31.46
Zeros2
Zeros (%)< 0.1%
Memory size116.5 KiB

Quantile statistics

Minimum-11.43
5-th percentile-0.00049605
Q16.2005
median12.21
Q317.8
95-th percentile23.785
Maximum31.46
Range42.89
Interquartile range (IQR)11.5995

Descriptive statistics

Standard deviation7.451711426
Coefficient of variation (CV)0.6191193021
Kurtosis-0.6934315498
Mean12.03598628
Median Absolute Deviation (MAD)6.256346189
Skewness-0.07406485769
Sum88235.81542
Variance55.52800317
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
16.9 20 0.3%
 
6.1 18 0.2%
 
5.3 16 0.2%
 
11.2 16 0.2%
 
16.5 16 0.2%
 
13.4 15 0.2%
 
10.6 15 0.2%
 
17.2 15 0.2%
 
11.8 15 0.2%
 
14.9 15 0.2%
 
Other values (3636) 7170 96.1%
 
(Missing) 127 1.7%
 
ValueCountFrequency (%) 
-11.43 1 < 0.1%
 
-10.69 1 < 0.1%
 
-10.14 1 < 0.1%
 
-9.505 1 < 0.1%
 
-9.356 1 < 0.1%
 
ValueCountFrequency (%) 
31.46 1 < 0.1%
 
31.42 1 < 0.1%
 
30.18 1 < 0.1%
 
30.06 1 < 0.1%
 
30.04 1 < 0.1%
 

Temp. (°C).1
Real number (ℝ)

HIGH CORRELATION
MISSING
Distinct count3139
Unique (%)42.8%
Missing124
Missing (%)1.7%
Infinite0
Infinite (%)0.0%
Mean16.741979733160623
Minimum-7.732
Maximum39.54
Zeros8
Zeros (%)0.1%
Memory size116.5 KiB

Quantile statistics

Minimum-7.732
5-th percentile2.64125
Q19.6905
median16.95
Q323.54
95-th percentile30.83
Maximum39.54
Range47.272
Interquartile range (IQR)13.8495

Descriptive statistics

Standard deviation8.826067819
Coefficient of variation (CV)0.5271818483
Kurtosis-0.8065052719
Mean16.74197973
Median Absolute Deviation (MAD)7.446631837
Skewness0.007748912133
Sum122785.6794
Variance77.89947315
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
21.2 16 0.2%
 
15.7 16 0.2%
 
17.4 15 0.2%
 
25 15 0.2%
 
20.7 14 0.2%
 
22.6 14 0.2%
 
12.6 14 0.2%
 
18.9 14 0.2%
 
13.7 14 0.2%
 
7.7 13 0.2%
 
Other values (3129) 7189 96.4%
 
(Missing) 124 1.7%
 
ValueCountFrequency (%) 
-7.732 1 < 0.1%
 
-7.029 1 < 0.1%
 
-5.555 1 < 0.1%
 
-5.383 1 < 0.1%
 
-5.268 1 < 0.1%
 
ValueCountFrequency (%) 
39.54 1 < 0.1%
 
38.78 1 < 0.1%
 
38.64 1 < 0.1%
 
38.3 1 < 0.1%
 
38.24 1 < 0.1%
 

Temp. (°C).2
Real number (ℝ)

HIGH CORRELATION
MISSING
Distinct count3058
Unique (%)41.8%
Missing138
Missing (%)1.9%
Infinite0
Infinite (%)0.0%
Mean7.934110150683059
Minimum-14.28
Maximum24.2
Zeros20
Zeros (%)0.3%
Memory size116.5 KiB

Quantile statistics

Minimum-14.28
5-th percentile-2.8686
Q12.888
median8.0415
Q313.22
95-th percentile18.0205
Maximum24.2
Range38.48
Interquartile range (IQR)10.332

Descriptive statistics

Standard deviation6.605726427
Coefficient of variation (CV)0.8325730676
Kurtosis-0.5693015324
Mean7.934110151
Median Absolute Deviation (MAD)5.531777047
Skewness-0.183567796
Sum58077.6863
Variance43.63562162
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 20 0.3%
 
1.6 19 0.3%
 
17 19 0.3%
 
12 18 0.2%
 
15.4 18 0.2%
 
6.5 17 0.2%
 
12.8 17 0.2%
 
11.6 16 0.2%
 
5.3 16 0.2%
 
14.6 16 0.2%
 
Other values (3048) 7144 95.8%
 
(Missing) 138 1.9%
 
ValueCountFrequency (%) 
-14.28 1 < 0.1%
 
-14.14 1 < 0.1%
 
-14.09 1 < 0.1%
 
-13.87 1 < 0.1%
 
-13.62 1 < 0.1%
 
ValueCountFrequency (%) 
24.2 1 < 0.1%
 
23.92 1 < 0.1%
 
23.9 1 < 0.1%
 
23.4 1 < 0.1%
 
23.19 1 < 0.1%
 

Feuchte (%)
Real number (ℝ≥0)

MISSING
Distinct count3303
Unique (%)47.3%
Missing471
Missing (%)6.3%
Infinite0
Infinite (%)0.0%
Mean66.40236716473451
Minimum0.05195
Maximum95.03
Zeros0
Zeros (%)0.0%
Memory size116.5 KiB

Quantile statistics

Minimum0.05195
5-th percentile45.96
Q157.455
median67.27
Q375.6
95-th percentile84.8
Maximum95.03
Range94.97805
Interquartile range (IQR)18.145

Descriptive statistics

Standard deviation12.03454345
Coefficient of variation (CV)0.1812366631
Kurtosis-0.404531555
Mean66.40236716
Median Absolute Deviation (MAD)9.974396244
Skewness-0.2501397089
Sum463953.3394
Variance144.830236
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
72.6 15 0.2%
 
79.8 13 0.2%
 
74 13 0.2%
 
56.4 13 0.2%
 
77.2 12 0.2%
 
76.4 12 0.2%
 
73 12 0.2%
 
70.8 12 0.2%
 
75.2 12 0.2%
 
73.1 11 0.1%
 
Other values (3293) 6862 92.0%
 
(Missing) 471 6.3%
 
ValueCountFrequency (%) 
0.05195 1 < 0.1%
 
0.05743 1 < 0.1%
 
26.7 1 < 0.1%
 
28.63 1 < 0.1%
 
29.02 1 < 0.1%
 
ValueCountFrequency (%) 
95.03 1 < 0.1%
 
94.12 1 < 0.1%
 
93.9 1 < 0.1%
 
93.49 1 < 0.1%
 
93.26 1 < 0.1%
 

WG (m/s)
Real number (ℝ≥0)

Distinct count5699
Unique (%)76.7%
Missing25
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean1.9815010800241601
Minimum0.6
Maximum7.155541666666665
Zeros0
Zeros (%)0.0%
Memory size116.5 KiB

Quantile statistics

Minimum0.6
5-th percentile1.1
Q11.5
median1.8
Q32.3
95-th percentile3.437666667
Maximum7.155541667
Range6.555541667
Interquartile range (IQR)0.8

Descriptive statistics

Standard deviation0.728233479
Coefficient of variation (CV)0.3675160647
Kurtosis3.384316905
Mean1.98150108
Median Absolute Deviation (MAD)0.5448153776
Skewness1.482079688
Sum14728.49753
Variance0.530324
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1.3 159 2.1%
 
1.2 149 2.0%
 
1.7 141 1.9%
 
1.6 132 1.8%
 
1.5 131 1.8%
 
1.4 127 1.7%
 
1.1 122 1.6%
 
1.8 106 1.4%
 
1 78 1.0%
 
2 64 0.9%
 
Other values (5689) 6224 83.5%
 
ValueCountFrequency (%) 
0.6 2 < 0.1%
 
0.6057 1 < 0.1%
 
0.7 10 0.1%
 
0.7075 1 < 0.1%
 
0.74033125 1 < 0.1%
 
ValueCountFrequency (%) 
7.155541667 1 < 0.1%
 
6.6434375 1 < 0.1%
 
6.6 1 < 0.1%
 
6.542354167 1 < 0.1%
 
6.354854167 1 < 0.1%
 

WG (m/s).1
Real number (ℝ≥0)

MISSING
Distinct count465
Unique (%)6.3%
Missing111
Missing (%)1.5%
Infinite0
Infinite (%)0.0%
Mean7.621054307880767
Minimum1.3
Maximum24.44
Zeros0
Zeros (%)0.0%
Memory size116.5 KiB

Quantile statistics

Minimum1.3
5-th percentile3.4
Q15.197
median7.009
Q39.409
95-th percentile13.96
Maximum24.44
Range23.14
Interquartile range (IQR)4.212

Descriptive statistics

Standard deviation3.329142381
Coefficient of variation (CV)0.4368348848
Kurtosis1.473044164
Mean7.621054308
Median Absolute Deviation (MAD)2.589069272
Skewness1.064998131
Sum55991.886
Variance11.08318899
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
4.2 55 0.7%
 
3.9 52 0.7%
 
5.589 49 0.7%
 
4 49 0.7%
 
7.549 48 0.6%
 
6.52 48 0.6%
 
4.3 47 0.6%
 
6.569 47 0.6%
 
8.136 47 0.6%
 
6.422 46 0.6%
 
Other values (455) 6859 92.0%
 
(Missing) 111 1.5%
 
ValueCountFrequency (%) 
1.3 1 < 0.1%
 
1.7 2 < 0.1%
 
1.9 3 < 0.1%
 
2 6 0.1%
 
2.1 12 0.2%
 
ValueCountFrequency (%) 
24.44 3 < 0.1%
 
23.81 1 < 0.1%
 
23.56 1 < 0.1%
 
22.39 1 < 0.1%
 
22.04 1 < 0.1%
 

WR (Grad)
Real number (ℝ≥0)

Distinct count6479
Unique (%)87.2%
Missing25
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean194.12179315242847
Minimum2.3
Maximum359.7
Zeros0
Zeros (%)0.0%
Memory size116.5 KiB

Quantile statistics

Minimum2.3
5-th percentile66.18533333
Q1153.6408271
median211.1354167
Q3234.5395833
95-th percentile274.56625
Maximum359.7
Range357.4
Interquartile range (IQR)80.89875625

Descriptive statistics

Standard deviation61.58151953
Coefficient of variation (CV)0.3172313553
Kurtosis0.2362935507
Mean194.1217932
Median Absolute Deviation (MAD)49.40653039
Skewness-0.7245584967
Sum1442907.289
Variance3792.283548
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
210 33 0.4%
 
211 28 0.4%
 
212 25 0.3%
 
213 17 0.2%
 
217 17 0.2%
 
226 16 0.2%
 
209 16 0.2%
 
215 14 0.2%
 
206 12 0.2%
 
225 11 0.1%
 
Other values (6469) 7244 97.1%
 
(Missing) 25 0.3%
 
ValueCountFrequency (%) 
2.3 1 < 0.1%
 
4.5 1 < 0.1%
 
5.3 1 < 0.1%
 
5.5 1 < 0.1%
 
8 2 < 0.1%
 
ValueCountFrequency (%) 
359.7 1 < 0.1%
 
357.3 1 < 0.1%
 
356.9 1 < 0.1%
 
356 1 < 0.1%
 
354 1 < 0.1%
 

Druck (hPa)
Real number (ℝ≥0)

MISSING
Distinct count1666
Unique (%)22.8%
Missing159
Missing (%)2.1%
Infinite0
Infinite (%)0.0%
Mean984.8181180863924
Minimum947.4
Maximum1011.3
Zeros0
Zeros (%)0.0%
Memory size116.5 KiB

Quantile statistics

Minimum947.4
5-th percentile970.8
Q1980.5
median985.4
Q3989.8
95-th percentile996.68
Maximum1011.3
Range63.9
Interquartile range (IQR)9.3

Descriptive statistics

Standard deviation7.769937413
Coefficient of variation (CV)0.007889718183
Kurtosis0.7318702585
Mean984.8181181
Median Absolute Deviation (MAD)5.975559739
Skewness-0.4634104218
Sum7188187.444
Variance60.37192741
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
986.3 48 0.6%
 
985.2 45 0.6%
 
987.8 44 0.6%
 
984.7 42 0.6%
 
985.3 40 0.5%
 
987.1 39 0.5%
 
988.3 39 0.5%
 
985.4 39 0.5%
 
986.8 39 0.5%
 
988.4 38 0.5%
 
Other values (1656) 6886 92.3%
 
(Missing) 159 2.1%
 
ValueCountFrequency (%) 
947.4 1 < 0.1%
 
949.5 1 < 0.1%
 
952.4 1 < 0.1%
 
953.4 1 < 0.1%
 
953.94 1 < 0.1%
 
ValueCountFrequency (%) 
1011.3 1 < 0.1%
 
1008 2 < 0.1%
 
1007.75 1 < 0.1%
 
1006.11 1 < 0.1%
 
1006.03 1 < 0.1%
 

Globalstr. (W/m²)
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
Distinct count4515
Unique (%)62.0%
Missing175
Missing (%)2.3%
Infinite0
Infinite (%)0.0%
Mean127.75841386791159
Minimum0.8552
Maximum422.9
Zeros0
Zeros (%)0.0%
Memory size116.5 KiB

Quantile statistics

Minimum0.8552
5-th percentile16.031
Q148.605
median110.5
Q3198
95-th percentile290
Maximum422.9
Range422.0448
Interquartile range (IQR)149.395

Descriptive statistics

Standard deviation89.6692545
Coefficient of variation (CV)0.7018657464
Kurtosis-0.8825559515
Mean127.7584139
Median Absolute Deviation (MAD)77.2825953
Skewness0.5081094296
Sum930464.5282
Variance8040.575203
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
114 8 0.1%
 
184.9 8 0.1%
 
139.5 7 0.1%
 
201.8 7 0.1%
 
213.1 7 0.1%
 
251.9 7 0.1%
 
138.5 7 0.1%
 
166.7 7 0.1%
 
120.2 7 0.1%
 
257.7 7 0.1%
 
Other values (4505) 7211 96.7%
 
(Missing) 175 2.3%
 
ValueCountFrequency (%) 
0.8552 1 < 0.1%
 
2.6 1 < 0.1%
 
3.483 1 < 0.1%
 
3.493 1 < 0.1%
 
4.124 1 < 0.1%
 
ValueCountFrequency (%) 
422.9 1 < 0.1%
 
367.2 1 < 0.1%
 
364.8 1 < 0.1%
 
362.3 1 < 0.1%
 
362 1 < 0.1%
 

UVA-Str. (W/m²)
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
Distinct count4332
Unique (%)59.7%
Missing204
Missing (%)2.7%
Infinite0
Infinite (%)0.0%
Mean6.877871932726771
Minimum0.62
Maximum26.5
Zeros0
Zeros (%)0.0%
Memory size116.5 KiB

Quantile statistics

Minimum0.62
5-th percentile2.25065
Q13.50025
median5.8575
Q39.485
95-th percentile14.9635
Maximum26.5
Range25.88
Interquartile range (IQR)5.98475

Descriptive statistics

Standard deviation4.079768579
Coefficient of variation (CV)0.5931730947
Kurtosis0.381905409
Mean6.877871933
Median Absolute Deviation (MAD)3.340482878
Skewness0.9412632574
Sum49892.083
Variance16.64451166
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.25 10 0.1%
 
0.87 10 0.1%
 
2.35 10 0.1%
 
10.52 10 0.1%
 
3.48 9 0.1%
 
10.22 9 0.1%
 
0.91 9 0.1%
 
10.55 9 0.1%
 
4.46 9 0.1%
 
2.5 9 0.1%
 
Other values (4322) 7160 96.0%
 
(Missing) 204 2.7%
 
ValueCountFrequency (%) 
0.62 1 < 0.1%
 
0.66 2 < 0.1%
 
0.7 2 < 0.1%
 
0.74 4 0.1%
 
0.78 1 < 0.1%
 
ValueCountFrequency (%) 
26.5 1 < 0.1%
 
24.71 1 < 0.1%
 
21.37 1 < 0.1%
 
21.22 1 < 0.1%
 
21.03 2 < 0.1%
 

UVB-Str. (W/m²)
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
Distinct count4116
Unique (%)56.7%
Missing205
Missing (%)2.7%
Infinite0
Infinite (%)0.0%
Mean0.1316872466565559
Minimum0.02103
Maximum0.6225
Zeros0
Zeros (%)0.0%
Memory size116.5 KiB

Quantile statistics

Minimum0.02103
5-th percentile0.030262
Q10.0481
median0.103
Q30.199
95-th percentile0.315
Maximum0.6225
Range0.60147
Interquartile range (IQR)0.1509

Descriptive statistics

Standard deviation0.0955091263
Coefficient of variation (CV)0.7252724066
Kurtosis-0.07544498154
Mean0.1316872467
Median Absolute Deviation (MAD)0.08033535421
Skewness0.8722217162
Sum955.1276
Variance0.009121993207
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.037 27 0.4%
 
0.032 25 0.3%
 
0.046 24 0.3%
 
0.033 24 0.3%
 
0.039 24 0.3%
 
0.035 23 0.3%
 
0.036 22 0.3%
 
0.038 22 0.3%
 
0.047 21 0.3%
 
0.051 21 0.3%
 
Other values (4106) 7020 94.1%
 
(Missing) 205 2.7%
 
ValueCountFrequency (%) 
0.02103 1 < 0.1%
 
0.02285 1 < 0.1%
 
0.02288 1 < 0.1%
 
0.023 1 < 0.1%
 
0.02308 1 < 0.1%
 
ValueCountFrequency (%) 
0.6225 1 < 0.1%
 
0.5027 1 < 0.1%
 
0.4766 1 < 0.1%
 
0.4646 1 < 0.1%
 
0.4584 1 < 0.1%
 

NO (µg/m³)
Real number (ℝ)

MISSING
Distinct count4315
Unique (%)64.3%
Missing748
Missing (%)10.0%
Infinite0
Infinite (%)0.0%
Mean20.574590956780924
Minimum-5.069
Maximum345.9
Zeros0
Zeros (%)0.0%
Memory size116.5 KiB

Quantile statistics

Minimum-5.069
5-th percentile1.693
Q15.05925
median10.995
Q324.9275
95-th percentile71.1325
Maximum345.9
Range350.969
Interquartile range (IQR)19.86825

Descriptive statistics

Standard deviation27.21410449
Coefficient of variation (CV)1.322704522
Kurtosis19.35834748
Mean20.57459096
Median Absolute Deviation (MAD)17.36586588
Skewness3.540919833
Sum138055.5053
Variance740.6074832
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1.6 29 0.4%
 
2.3 27 0.4%
 
1.7 25 0.3%
 
1.8 25 0.3%
 
2.8 23 0.3%
 
1.2 23 0.3%
 
2.1 22 0.3%
 
1.4 22 0.3%
 
3 21 0.3%
 
5.7 21 0.3%
 
Other values (4305) 6472 86.8%
 
(Missing) 748 10.0%
 
ValueCountFrequency (%) 
-5.069 1 < 0.1%
 
-3.768 1 < 0.1%
 
-2.708 1 < 0.1%
 
-2.319 1 < 0.1%
 
-2.264 1 < 0.1%
 
ValueCountFrequency (%) 
345.9 1 < 0.1%
 
324 1 < 0.1%
 
261.5 1 < 0.1%
 
258.9 1 < 0.1%
 
258 1 < 0.1%
 

NO2 (µg/m³)
Real number (ℝ)

MISSING
Distinct count3575
Unique (%)53.4%
Missing761
Missing (%)10.2%
Infinite0
Infinite (%)0.0%
Mean33.648299522174106
Minimum-8.038
Maximum138.8
Zeros9
Zeros (%)0.1%
Memory size116.5 KiB

Quantile statistics

Minimum-8.038
5-th percentile11.208
Q121.83
median31.25
Q342.95
95-th percentile63.45
Maximum138.8
Range146.838
Interquartile range (IQR)21.12

Descriptive statistics

Standard deviation16.61600421
Coefficient of variation (CV)0.4938140842
Kurtosis2.067116393
Mean33.64829952
Median Absolute Deviation (MAD)12.84758919
Skewness1.00604148
Sum225342.6619
Variance276.0915961
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
29.3 15 0.2%
 
22.3 14 0.2%
 
33.7 12 0.2%
 
21.9 12 0.2%
 
14.7 11 0.1%
 
18.1 11 0.1%
 
28.3 11 0.1%
 
32.4 11 0.1%
 
31.4 11 0.1%
 
23.7 11 0.1%
 
Other values (3565) 6578 88.2%
 
(Missing) 761 10.2%
 
ValueCountFrequency (%) 
-8.038 1 < 0.1%
 
-7.705 1 < 0.1%
 
-5.251 1 < 0.1%
 
-5.134 1 < 0.1%
 
-4.817 1 < 0.1%
 
ValueCountFrequency (%) 
138.8 1 < 0.1%
 
135.6 1 < 0.1%
 
132.2 1 < 0.1%
 
126.8 1 < 0.1%
 
124.6 1 < 0.1%
 

O3 (µg/m³)
Real number (ℝ≥0)

MISSING
Distinct count3870
Unique (%)55.6%
Missing498
Missing (%)6.7%
Infinite0
Infinite (%)0.0%
Mean23.004280090086205
Minimum0.0
Maximum99.93
Zeros4
Zeros (%)0.1%
Memory size116.5 KiB

Quantile statistics

Minimum0
5-th percentile3.91795
Q111.6
median21.24
Q331.2
95-th percentile50.3905
Maximum99.93
Range99.93
Interquartile range (IQR)19.6

Descriptive statistics

Standard deviation14.36667965
Coefficient of variation (CV)0.6245220279
Kurtosis0.9654737697
Mean23.00428009
Median Absolute Deviation (MAD)11.29048733
Skewness0.8991516157
Sum160109.7894
Variance206.4014842
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
9.6 15 0.2%
 
16.4 14 0.2%
 
27.1 14 0.2%
 
20.4 14 0.2%
 
9.5 13 0.2%
 
20.9 13 0.2%
 
23 13 0.2%
 
21 12 0.2%
 
9.7 12 0.2%
 
19.9 12 0.2%
 
Other values (3860) 6828 91.6%
 
(Missing) 498 6.7%
 
ValueCountFrequency (%) 
0 4 0.1%
 
0.003077 1 < 0.1%
 
0.01904 1 < 0.1%
 
0.0271 1 < 0.1%
 
0.03224 1 < 0.1%
 
ValueCountFrequency (%) 
99.93 1 < 0.1%
 
96 1 < 0.1%
 
92.52 1 < 0.1%
 
91.07 1 < 0.1%
 
88.02 1 < 0.1%
 

SO2 (µg/m³)
Real number (ℝ)

MISSING
Distinct count2685
Unique (%)85.6%
Missing4322
Missing (%)58.0%
Infinite0
Infinite (%)0.0%
Mean6.653081485459183
Minimum-3.913
Maximum44.69
Zeros40
Zeros (%)0.5%
Memory size116.5 KiB

Quantile statistics

Minimum-3.913
5-th percentile-0.28315
Q11.82375
median5.15
Q310.32
95-th percentile17.755
Maximum44.69
Range48.603
Interquartile range (IQR)8.49625

Descriptive statistics

Standard deviation6.241966119
Coefficient of variation (CV)0.9382067743
Kurtosis2.056363712
Mean6.653081485
Median Absolute Deviation (MAD)4.938184733
Skewness1.19908216
Sum20864.06354
Variance38.96214104
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 40 0.5%
 
10.32 5 0.1%
 
10.75 4 0.1%
 
11.18 4 0.1%
 
5.279 4 0.1%
 
13.83 4 0.1%
 
10.62 4 0.1%
 
14.92 4 0.1%
 
10.78 4 0.1%
 
16.86 4 0.1%
 
Other values (2675) 3059 41.0%
 
(Missing) 4322 58.0%
 
ValueCountFrequency (%) 
-3.913 1 < 0.1%
 
-3.908 1 < 0.1%
 
-3.891 1 < 0.1%
 
-3.8 1 < 0.1%
 
-3.796 1 < 0.1%
 
ValueCountFrequency (%) 
44.69 1 < 0.1%
 
40.62 1 < 0.1%
 
37.69 1 < 0.1%
 
37.22 1 < 0.1%
 
35.97 1 < 0.1%
 

CO (mg/m³)
Real number (ℝ≥0)

MISSING
Distinct count1193
Unique (%)93.4%
Missing6181
Missing (%)82.9%
Infinite0
Infinite (%)0.0%
Mean0.39035426781519184
Minimum0.02383
Maximum2.984
Zeros0
Zeros (%)0.0%
Memory size116.5 KiB

Quantile statistics

Minimum0.02383
5-th percentile0.051368
Q10.1065
median0.2125
Q30.5991
95-th percentile1.1842
Maximum2.984
Range2.96017
Interquartile range (IQR)0.4926

Descriptive statistics

Standard deviation0.3864377315
Coefficient of variation (CV)0.9899667132
Kurtosis2.31151345
Mean0.3903542678
Median Absolute Deviation (MAD)0.3116974906
Skewness1.459256299
Sum498.4824
Variance0.1493341203
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.1054 5 0.1%
 
0.1286 4 0.1%
 
1.119 3 < 0.1%
 
0.1319 3 < 0.1%
 
0.1111 3 < 0.1%
 
1.131 3 < 0.1%
 
1.037 3 < 0.1%
 
0.1551 3 < 0.1%
 
0.2348 3 < 0.1%
 
0.1365 2 < 0.1%
 
Other values (1183) 1245 16.7%
 
(Missing) 6181 82.9%
 
ValueCountFrequency (%) 
0.02383 1 < 0.1%
 
0.02447 1 < 0.1%
 
0.02622 1 < 0.1%
 
0.02643 1 < 0.1%
 
0.02885 1 < 0.1%
 
ValueCountFrequency (%) 
2.984 1 < 0.1%
 
2.425 1 < 0.1%
 
2.112 1 < 0.1%
 
1.678 1 < 0.1%
 
1.564 1 < 0.1%
 

Niederschlag (l/m²)
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count1523
Unique (%)21.9%
Missing489
Missing (%)6.6%
Infinite0
Infinite (%)0.0%
Mean1.430604021667384
Minimum0.0
Maximum51.1
Zeros3065
Zeros (%)41.1%
Memory size116.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.04
Q31.16
95-th percentile7.8
Maximum51.1
Range51.1
Interquartile range (IQR)1.16

Descriptive statistics

Standard deviation3.433907469
Coefficient of variation (CV)2.400320017
Kurtosis31.68469001
Mean1.430604022
Median Absolute Deviation (MAD)1.972600481
Skewness4.617354949
Sum9969.879427
Variance11.79172051
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 3065 41.1%
 
0.01 97 1.3%
 
0.02 82 1.1%
 
0.05 78 1.0%
 
0.1 77 1.0%
 
0.03 68 0.9%
 
0.04 62 0.8%
 
0.07 50 0.7%
 
0.06 50 0.7%
 
0.11 43 0.6%
 
Other values (1513) 3297 44.2%
 
(Missing) 489 6.6%
 
ValueCountFrequency (%) 
0 3065 41.1%
 
0.003 1 < 0.1%
 
0.004 3 < 0.1%
 
0.005 33 0.4%
 
0.009 8 0.1%
 
ValueCountFrequency (%) 
51.1 1 < 0.1%
 
43.8 1 < 0.1%
 
40.81 1 < 0.1%
 
37.26 1 < 0.1%
 
35.68 1 < 0.1%
 

Str.-Bilanz (W/m²)
Real number (ℝ)

MISSING
Distinct count5121
Unique (%)76.1%
Missing731
Missing (%)9.8%
Infinite0
Infinite (%)0.0%
Mean35.176040228928194
Minimum-501.0
Maximum1079.0
Zeros3
Zeros (%)< 0.1%
Memory size116.5 KiB

Quantile statistics

Minimum-501
5-th percentile-29.942
Q1-6.274
median23.09
Q373.195
95-th percentile138.4
Maximum1079
Range1580
Interquartile range (IQR)79.469

Descriptive statistics

Standard deviation64.05212081
Coefficient of variation (CV)1.820901966
Kurtosis26.50241731
Mean35.17604023
Median Absolute Deviation (MAD)46.95859745
Skewness0.8730035856
Sum236629.2226
Variance4102.67418
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
103.3 13 0.2%
 
-17.4 7 0.1%
 
-21.9 7 0.1%
 
-20.5 6 0.1%
 
0.6 6 0.1%
 
-20.3 6 0.1%
 
-4.9 6 0.1%
 
-13.4 6 0.1%
 
-10.8 6 0.1%
 
1.6 5 0.1%
 
Other values (5111) 6659 89.3%
 
(Missing) 731 9.8%
 
ValueCountFrequency (%) 
-501 3 < 0.1%
 
-484.3 1 < 0.1%
 
-481.6 1 < 0.1%
 
-478.6 1 < 0.1%
 
-435.2 1 < 0.1%
 
ValueCountFrequency (%) 
1079 1 < 0.1%
 
973.8 1 < 0.1%
 
739 1 < 0.1%
 
601.6 1 < 0.1%
 
346 1 < 0.1%
 

PM10 (µg/m³)
Real number (ℝ)

MISSING
Distinct count2870
Unique (%)49.1%
Missing1615
Missing (%)21.7%
Infinite0
Infinite (%)0.0%
Mean20.300020818654115
Minimum-64.06
Maximum211.7
Zeros5
Zeros (%)0.1%
Memory size116.5 KiB

Quantile statistics

Minimum-64.06
5-th percentile6.8847
Q112.57
median18.11
Q325.365
95-th percentile40.03
Maximum211.7
Range275.76
Interquartile range (IQR)12.795

Descriptive statistics

Standard deviation11.86532013
Coefficient of variation (CV)0.5844979292
Kurtosis28.09428994
Mean20.30002082
Median Absolute Deviation (MAD)8.376903426
Skewness2.896830238
Sum118613.0216
Variance140.7858218
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
15.2 14 0.2%
 
11.4 14 0.2%
 
13.9 13 0.2%
 
16.9 13 0.2%
 
12.8 12 0.2%
 
7.3 12 0.2%
 
10.7 12 0.2%
 
6 11 0.1%
 
8.3 11 0.1%
 
10.8 11 0.1%
 
Other values (2860) 5720 76.7%
 
(Missing) 1615 21.7%
 
ValueCountFrequency (%) 
-64.06 1 < 0.1%
 
-25.19 1 < 0.1%
 
-4.315 1 < 0.1%
 
-1.308 1 < 0.1%
 
0 5 0.1%
 
ValueCountFrequency (%) 
211.7 1 < 0.1%
 
202.4591667 1 < 0.1%
 
157.2 1 < 0.1%
 
98.58 1 < 0.1%
 
96.11 1 < 0.1%
 

PM2.5 (µg/m³)
Real number (ℝ≥0)

MISSING
Distinct count659
Unique (%)45.4%
Missing6007
Missing (%)80.5%
Infinite0
Infinite (%)0.0%
Mean12.529251221523829
Minimum0.0
Maximum185.19937500000003
Zeros4
Zeros (%)0.1%
Memory size116.5 KiB

Quantile statistics

Minimum0
5-th percentile3.5
Q17.1
median10.9
Q315.65
95-th percentile26.935
Maximum185.199375
Range185.199375
Interquartile range (IQR)8.55

Descriptive statistics

Standard deviation8.87528076
Coefficient of variation (CV)0.7083648179
Kurtosis102.7944955
Mean12.52925122
Median Absolute Deviation (MAD)5.710807156
Skewness6.300967715
Sum18179.94352
Variance78.77060856
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10.5 14 0.2%
 
13.5 13 0.2%
 
5.9 12 0.2%
 
8.5 12 0.2%
 
10.3 12 0.2%
 
10 11 0.1%
 
7 11 0.1%
 
14 11 0.1%
 
8.1 11 0.1%
 
5.6 11 0.1%
 
Other values (649) 1333 17.9%
 
(Missing) 6007 80.5%
 
ValueCountFrequency (%) 
0 4 0.1%
 
0.3763 1 < 0.1%
 
0.4825 1 < 0.1%
 
1.5 1 < 0.1%
 
1.513 1 < 0.1%
 
ValueCountFrequency (%) 
185.199375 1 < 0.1%
 
87.01 1 < 0.1%
 
64.9 1 < 0.1%
 
50 1 < 0.1%
 
47.5 1 < 0.1%
 

KFZ_ges
Real number (ℝ≥0)

MISSING
Distinct count5459
Unique (%)93.4%
Missing1613
Missing (%)21.6%
Infinite0
Infinite (%)0.0%
Mean73857.71633875107
Minimum26533.0
Maximum99162.0
Zeros0
Zeros (%)0.0%
Memory size116.5 KiB

Quantile statistics

Minimum26533
5-th percentile45311.8
Q161707
median79446
Q385504
95-th percentile91677.8
Maximum99162
Range72629
Interquartile range (IQR)23797

Descriptive statistics

Standard deviation15191.23389
Coefficient of variation (CV)0.2056824207
Kurtosis-0.5758117759
Mean73857.71634
Median Absolute Deviation (MAD)12924.22695
Skewness-0.7474942295
Sum431698352
Variance230773586.9
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
75847 3 < 0.1%
 
86124 3 < 0.1%
 
82988 3 < 0.1%
 
84056 3 < 0.1%
 
92157 3 < 0.1%
 
85943 3 < 0.1%
 
80800 3 < 0.1%
 
87263 3 < 0.1%
 
59463 3 < 0.1%
 
84621 3 < 0.1%
 
Other values (5449) 5815 78.0%
 
(Missing) 1613 21.6%
 
ValueCountFrequency (%) 
26533 1 < 0.1%
 
27946 1 < 0.1%
 
28331 1 < 0.1%
 
29193 1 < 0.1%
 
29235 1 < 0.1%
 
ValueCountFrequency (%) 
99162 1 < 0.1%
 
99010 1 < 0.1%
 
98772 1 < 0.1%
 
98722 1 < 0.1%
 
98505 1 < 0.1%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Missing values

Sample

First rows

DatumTemp. (°C)Temp. (°C).1Temp. (°C).2Feuchte (%)WG (m/s)WG (m/s).1WR (Grad)Druck (hPa)Globalstr. (W/m²)UVA-Str. (W/m²)UVB-Str. (W/m²)NO (µg/m³)NO2 (µg/m³)O3 (µg/m³)SO2 (µg/m³)CO (mg/m³)Niederschlag (l/m²)Str.-Bilanz (W/m²)PM10 (µg/m³)PM2.5 (µg/m³)KFZ_ges
02000-01-013.7185.7002.138086.831.9598967.450234.922917991.8NaN2.6260.03100NaNNaN13.60010.3800.9109NaNNaNNaNNaNNaN
12000-01-023.8486.7061.299090.692.1729137.891222.511250996.9NaN4.0690.04113NaNNaN16.91010.7400.8870NaNNaNNaNNaNNaN
22000-01-031.4632.7060.408888.482.2952086.030220.181250996.2NaN2.3960.02885NaNNaN15.40010.2900.8394NaNNaNNaNNaNNaN
32000-01-044.9347.7470.882877.373.5749799.703220.885417989.9NaN3.0370.03510NaNNaN22.43013.4200.7822NaNNaNNaNNaNNaN
42000-01-056.91710.0702.034083.522.2372089.115220.554167989.7NaN2.9640.03395NaNNaN16.03014.2701.1890NaNNaNNaNNaNNaN
52000-01-063.9447.9450.851686.451.9982967.156208.717500989.0NaN3.8540.03859NaNNaN12.57013.3200.9006NaNNaNNaNNaNNaN
62000-01-076.3067.8524.966082.761.7194358.038195.322708991.4NaN2.2930.02927NaNNaN11.49015.9201.3520NaNNaNNaNNaNNaN
72000-01-086.6829.1223.690075.841.7457445.883215.767708990.1NaN3.9120.04089NaNNaN11.80017.5701.1640NaNNaNNaNNaNNaN
82000-01-095.7396.6174.732094.121.4129404.512126.481667989.9NaN2.1330.02831NaNNaN11.5709.6861.1690NaNNaNNaNNaNNaN
92000-01-103.2305.1641.794095.031.9631195.246184.978396997.9NaN1.9170.02588NaNNaN9.78811.2101.0140NaNNaNNaNNaNNaN

Last rows

DatumTemp. (°C)Temp. (°C).1Temp. (°C).2Feuchte (%)WG (m/s)WG (m/s).1WR (Grad)Druck (hPa)Globalstr. (W/m²)UVA-Str. (W/m²)UVB-Str. (W/m²)NO (µg/m³)NO2 (µg/m³)O3 (µg/m³)SO2 (µg/m³)CO (mg/m³)Niederschlag (l/m²)Str.-Bilanz (W/m²)PM10 (µg/m³)PM2.5 (µg/m³)KFZ_ges
74482020-05-2315.321.210.074.01.94.7232.0992.9654.33.710.0792.015.3NaNNaNNaN6.0-8.4NaNNaNNaN
74492020-05-2414.819.49.857.33.27.6265.0998.64238.211.130.2251.18.6NaNNaNNaN0.0147.3NaNNaNNaN
74502020-05-2516.320.312.258.82.27.8237.01000.06177.78.830.1941.814.1NaNNaNNaN0.0105.5NaNNaNNaN
74512020-05-2616.121.19.954.61.84.8187.01001.18246.310.710.2375.721.1NaNNaNNaN0.0124.3NaNNaNNaN
74522020-05-2717.324.18.948.31.75.1212.01000.09282.112.250.2776.121.7NaNNaNNaN0.0146.8NaNNaNNaN
74532020-05-2817.321.812.448.92.46.128.0996.45235.710.790.2274.223.5NaNNaNNaN0.0136.1NaNNaNNaN
74542020-05-2916.221.29.444.82.25.6129.0993.43237.910.320.2172.818.7NaNNaNNaN0.0105.5NaNNaNNaN
74552020-05-3015.920.69.347.42.47.127.0989.46215.49.610.2052.418.4NaNNaNNaN0.0104.9NaNNaNNaN
74562020-05-3116.721.910.442.72.05.361.0988.27258.811.500.2561.613.0NaNNaNNaN0.0131.8NaNNaNNaN
74572016-01-29NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN94073.0